EXPEDIENTE

"192.168.0.1:sipop"

EXPEDIENTE

Descriptions

REGISTRO DE EXPEDIENTE POR PERSONA

Fields

Name	Data type	Description
ID_EXPEDIENTE	CHAR (8)	ID del expediente
PERSONA	CHAR (8)	Persona registrada para este expediente
FECHA_INSCRIPCION	DATE	Fecha de inscripcion del expediente

Triggers

There are no triggers for table EXPEDIENTE

Indices

There are no indices for table EXPEDIENTE

References

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
PERSONA	INTEG_258	PERSONA	ID_PERSONA	RESTRICT	RESTRICT

Referenced

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
DETALLE_VISITAS	INTEG_129	COD_EXPEDIENTE	ID_EXPEDIENTE	RESTRICT	RESTRICT
HOJADESERVICIO	INTEG_265	COD_EXPEDIENTE	ID_EXPEDIENTE	RESTRICT	RESTRICT
PATOPOREXPE	INTEG_274	EXPEDIENTE	ID_EXPEDIENTE	RESTRICT	RESTRICT

Definition


CREATE TABLE EXPEDIENTE (
    ID_EXPEDIENTE CHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    PERSONA CHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    FECHA_INSCRIPCION DATE NOT NULL);

ALTER TABLE EXPEDIENTE ADD PRIMARY KEY (ID_EXPEDIENTE);
ALTER TABLE EXPEDIENTE ADD  FOREIGN KEY (PERSONA) REFERENCES PERSONA (ID_PERSONA);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.